Re: Suggestions for pipe...
I've got 3 hookahs: a KM dual pear, a Sahara Cyclone, and a brand-less chinese. I'd suggest a KM or a syrian/nour/temsah like most other people. I like my KM because it looks good, has a traditional chamber, and gets smoke from point A to point B deliciously.
Have a look at Photolinger's sticky and visit the vendors to find something you think looks good and fits your budget. From what you've said it looks like you're off to a good start. You'll get addicted to collecting hookahs in no time!