An independent school has acquired exclusive rights to all water sports on a major reservoir in a beauty spot.