Cave Run lake is has a most of what you are looking for and its not too far past Northern KY. If you don't mind driving 40 minutes farther you could check Laurel Lake. It's one of our most beautiful lakes and the water is crystal clear. There are boat-in campsites as well as regular campgrounds. The only thing is, in July sometimes the best fishing is at night.