As far as equipment goes:
1. A good tripod is required. I have bought the cheap K-Mart/Walmart tripods and have a collection of them going. With the cheaper ones you end up with legs and the various angle adjustments slipping. IMHO you don't need a super expensive professional tripod, but you don't want the bottom of the line either. A rough estimate is to stay away from $35 and under tripods, but hopefully a $50 - $60 tripod will suit you perfectly.
2. The camera. I've had three digital cameras, an Olympus Camedia 2300, a Nikon CoolPix 880 and my newest camera a Canon Digital Rebel EOS. Megapixels, for general use are over-rated, as long as you've got at least 2 MPs. My Olympus had 2.1 while the Nikon had over 3, yet the Olympus was a more usable camera for Macro pictures of knives because of the 3X optical zoom. My point here is that the lens abilities are the most important aspect of the camera. Thats the reason that I love the Rebel, number 1 its an SLR and two, its got a 28mm to 55mm zoom lens. The macros I can get with this camera without having to resort to a lot of fiddling with Adobe Photopaint is really impressive and makes this camera worth being almost 3 times as expensive as my other two cameras. With the cheaper fixed lenses you're stuck with a fixed focal point which makes it tough to not have to use digital enhancing to get the picture you need. With an SLR your focal point is variable depending upon your situation.
Bottom line, you can take great pictures with an inexpensive camera and a cheap tripod, you just have to work a whole lot harder, spend a lot of time practicing and have decent photo editing software.