I used to play A LOT and I really miss it.
Pool cues are like anything else, there are so many to choose from.
I have a McDermott Competition series, MG-21 I believe.
http://www.mcdermottcue.com/Competitor.asp
I played a bunch of cues before I settled. My stepfather who got me into it has a Lucasi, which are really nice but pricey. I like mine quite a bit, it is not fancy looking which is good b/c you aren't shelling out a bunch of cash for inlays and fancy wood. I also really like the "wood to wood" joint since I feel like it makes for a softer feel than a one with a metal piece in between the shaft and the butt.
What is really important is finding the right weight for you. Do you notice when you use house cues what weight you are comfortable with? I'd say 19.5 or 20 oz is probably the middle of the road.
My main recommendation would be NOT to cheap out with a department store cue. Spending 40-50 on one of those is a total waste of money when there are so many good cues between $100-$200. Try ebay.
Once you get yourself a cue make sure you take good care it, watch where you lean it so it doesn't fall and the shaft doesn't get nicked and break with a house cue.
Enjoy your new hobby!