As Britain’s C2C long-distance cycle route celebrates 30 years, discover some other great options for cycling holidays close to home