Hi,
dunno about campsites with watersports, but there are activities at the scaling reservoir nr guisborough.
Nearby sites I could recommend would be cote ghyll and golden square
A day of all things motorhome and campervan. The show is held both in the main indoor arena and across the grounds. Catering, hot drinks and food options are available. Easy access to the site and free parking included. Win one of five pairs of day tickets