There is a lot of kayaking in the Pictured Rocks area if you have a sea kayak. They kayak in and about the Rocks area. Contact the Pictured Rocks National Park for info. You may also want to visit Grand Island. Contact the Hiawatha National Forest for information on Grand Island.
I've done a lot of scuba diving in the area. A lot of shipwrecks to visit.