Talented Abertay footballer scoops prize named after his best friend who died in a tragic accident