Club legend Spears to retire at end of season