From the age of six, Reggie Dwight followed Watford FC’s fortunes avidly – and when he became the multimillionaire Elton John decided to do all he could to improve them