In reply to The Lemming:
manfrotto 055 series is pretty good and i'd heartily reccomend one.
the metal version is actually more stable than the carbon version so get that one! strange but true. also a sneaky tip is, try and find the 'manfrotto 055 view tripod'. it doesnt have the crazy spider thing on top which can cause a little instability with some heads, hard to source though. my friend has one and a regular 055 and he seems to think its a fair bit better.
my opinion of a tripod is that if you're going to use one you might as well use the best one possible. i have a big heavy one designed for super-telephots and its 110% totally awesome. but unless you're shooting large teles theres probably not much point spending too much on one