I live in Campbell and the only one I know of is Lloyd range as well. You're best bet would be to contact the various private clubs and see if they are taking new members, or if you know someone in a club, see if they can hook you up. There's a gun shop called Shooter's or something like that, it was near where Independence and Covington converge on Rt. 17 that supposedly bought some land to have a range, but I've never been to it, nor do I know anyone that has. Or better yet, buy some land and open one. LOL.
If you're just shooting pistols, there's Mark's Gun Shop in Florence that has a pistol range, as does Bud's Gun Shop in Paris, KY.