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
Amazing family weekend with old steam engines, classic car displays, market stalls, and full catering and bar. And camping on site - Save £25 by booking in advance.