Levy’s 24-year tenure brought financial gains and world class facilities but limited success on the pitch