As the ice melts over the next month it will be easier to find spots. There are three quarries in Northern Ohio and one in Michigan. My Dive Center runs the scuba concession at White Star Quarry (see link below) and it opens April 1. Portage Quarry is in Bowling Green and It opens the end of April I think. Gilboa Quarry, a little further south is in Gilboa, Ohio and I am pretty sure it is open year round but call ahead for ice conditions. The Michigan quarry is in Monroe and I am not sure when they open. Closer to you there is Lake Huron, the St Claire River, Higgins Lake, Maceday Lake, Orchard lake and Spring Mill Pond. Some need a little more skill than others. My guess is that your best bet will be to get with the people at your Local Dive Center and ask them for their fun dive dates. I know we do a fun dive at least every two weeks and are diving somewhere every weekend at our Dive Center, Divers Incorporated.
Hope to see you diving this summer.
Rich