I can only personally comment on rodent eating snakes (keep in mind you don't have to feed live, you can feed frozen/thawed). If you go with a rodent eating snake, I highly recommend a cornsnake or Mexican Black Kingsnake as a great beginner snake. Both have great feeding responses and getting them to eat f/t should be no problem. Easy care requirements. Corns come in great colors. Mex Black Kings are a bit faster. I'd also recommend a Kenyan Sand Boa - they're great too, but do stay buried under the substrate a lot. Those are the only snakes I have personal experience with.
Others have often recommended Children's pythons, Spotted Pythons, Brown snakes.
I stop by the Indy show every month. I don't think I've ever really seen any non-rodent eating species. They're not to popular at the show. If you do decide to go with a rodent eating snake, (depending on the species) I can recommend some good breeders that visit the show. I only buy from certain breeders - not just anyone. However, it is important that you do have a cage/tank setup before bringing a new snake home.
I'd recommend maybe just looking to see what's out there, come home do some research, get your setup together and then plan to buy at next months show. It's the breeder expo so should be a good one.
You might check out the small terrestrial snake forum, but again not sure you'll really find any at the Indy show.
-----
Check Out My Albums
1.0 Ball Python "Aragorn"
1.0 Kenyan Sand Boa "Gimli"
1.0 Saharan Sand Boa "Frodo"
0.1 Rough-Scale Sand Boa "Arwen"
0.1 California Kingsnake "Gentoo"
1.0 Mexican Black Kingsnake "Indigo"
1.0 Snow Corn snake "Chile"
0.1 Australian Cattle Dog/Pointer
"Kira"