He was known for 'scoring the most spectacular goals' and was a popular teammate