Art - Used to live in Cincinnati for a few years after college. The Little Miami River (LMR) is only a 15 min drive from the center of Cincinnati (located on east side) and offers some great fishing for Smallies, Hybrids, White Bass and some other species. One of the better spots I used to go to was just south of the 125 bridge (Beechmont Ave). You can walk along the shore and wade at certain points. Key in on the riffles and fish tight to rocks if you're looking for big Hybrids. There are a number of other easy access points all along the LMR if you look on google maps. You could also rent a kayak from one of the local companies and float a good section of the river.
Delamere and Hopkins is the local fly fishing shop and they'll be able to provide you with a ton of helpful information. Hope this helps.
Eric