From tranquil kayaking excursions on serene lakes to heart-pounding whitewater rafting expeditions, there’s something for every water lover here.