In the northeast: Williams, Dartmouth, Bowdoin, Bates, Colby, Middlebury, St. Lawrence, Hamilton, Cornell, Ithaca, SUNY Geneseo. These colleges are all in great locations for hiking, canoeing, etc. and many have active Outing Clubs and freshman orientation trips that involve camping.
St. Mary’s College of Maryland (Located in St. Mary’s, Maryland) is on the St. Mary’s River. They offer sailboats and canoes for students to checkout and use.
Everyone bikes to get around on campus.
Montana State University-Bozeman or University of Montana are great for people who like the outdoors. They are academically marginal, but Montana is really pretty.