Supernatural actor dies aged 51 as co-star shares emotional tribute