There are a handful of different ways. Yes a tripod is a must, along with mirror lock, and Delayed shutter release.
I use a cheap wall mart tripod and bellows and it works well enough for me. As far as lenses go I have macro shot super close with all sorts of lenses including a 50mm 1.4 standard prime (used
here). Although one of my favorites is prolly a 135mm (Setup seen
Here)
When shooting macro like this, stationary objects is your best friend. When using mirror lock, delayed release, long exposures, and small apertures some really neat things can be done with Macro.
Additionally, I like to keep several flashlights handy, they are far more reliable than a flash for those tricky lighting situations. In fact I won't use a flash for macro work my self, but there are others here that swear by them.
*EDIT*
WOW, I misread the OP, I second what epp_b sais, use a longer lens.