Try University of Minnesota - Twin Cities, or their Duluth campus, for lot’s of lake and river action.
In the west, Quest in British Columbia has outdoor/water options, as well Evergreen in Olympia Washington, which has tons of kayaking and other beach and water sports on Puget Sound.
University of Montana has some of the best river sports, as well as robust outdoor programs in general.
University of Wisconsin - Madison is near lakes and rivers, as is Michigan State U.
University of Vermont could also fit the bill, as it’s Lake Champlain adjacent and students their also have a strong outdoor orientation.