This property near a stunning reservoir is amazing and only rarely comes up for sale