Depending on where you live in the Detroit area, pick a few dive shops near where you live and give them a visit or call. I've never been to a shop that does not offer classes. Pick one you are comfortable with. Also check the community education in your community as they may offer classes (normally affiliated with a dive shop).
I think it is common here for students to do the first part of the class (pool and book work) locally and travel to a warmer location (Florida, Caribbean) while others opt for more local quarry dives for their open water certification dives. These options are often offered through your local dive shop as a referral.