What to get depends quite a bit on your budget, but for an ideal setup:
1) Flash mounts -
My very flexible Macro flashbracket: Lighting Technique Forum: Digital Photography Review this RAM mount setup as shown in the link is one that is proving to be popular with many. It's also one that I've started using and I find it to be a great and versatile setup which is also strong enough to steadily hold the heavier flashes. Note that whilst its price might seem high compared to cheap brackets sold on
ebay, my experience is that for most speedlite sized flashes the cheap
ebay options are typically not sturdy enough in construction for close up macro work (they wobble far too much).
2) Tripod legs is a big area and tricky without an idea of budget. Manfrotto 055XPROB are a popular choice, but I would recommend an older manfrotto 055 model which does not have the angled centre column design, but rather the original setup which is a removable middle section and then a plate that is put onto the legs - this allows for a low height mounting, but also does not suffer from moving your tripod head to a 90degree angle off its normal position (which the newer design does at low heights).
3) Tripod heads is easy - Manfrotto Junior Geared head - not cheap, but the best budget option for pure macro work - the fine controls on each of the 3 axis makes it very easy to use for macro work and composing a photo; however the fine controls also mean that the head is useless for any motion tracking or fast setups. Otherwise I would go for a 3 way head if you have a smaller budget. I would avoid ballheads totally because whilst they are fast, they nearly all suffer from a small droop when you lock them down and release your hands from the setup. Normal shooting never shows this, but macro does and it makes a significant change to the framing (and its a right pain). Some of the top range ballheads are far better, but they also come with a heavier price tag
4) You'll also need a focusing rail for tripod work - and a cheap set of
Adorama focusing rails or the same design from ebay (focusing rails in search will give you loads of vendors) are about the best (far better than the manfrotto) for budget; whilst going higher you hit the likes of the Novoflex rails (very good but very pricey).