Gilboa Quarry (HUGE fish, cold water), Portsmouth, Circleville and Erie all have diving.
Underwater Connection in Grandview (cheap and good people) <-- good dive shop Trowa if your Dr says it is ok you can go practice at UC, call Bill and tell him about it.
Aquatic Adventures (expensive a$$holes) <-- new dive shop
I have been diving in St. Louis at Bonne Terre, Disney right in the shark tank, Cozumel at scuba club, Key Largo with Rainbow Reef, Ft. Lauderdale with a few places. I love it, I have all of my own gear.