Plans for a football stadium and 3G pitches for a club without facilities have been dropped after the council advised plans would be refused.