A rundown recreation ground could be transformed into a £10.7 million sports and health hub featuring football pitches, padel courts and a café.