Has the tripod got a ball and socket head? i,m interested if it has.
What kind of camera are you after? compact dslr or in between?
For compact one of the best out is a
Sony Cyber-shot DSC-P200 Digital Camera for about £230
DSLR you want to be looking at a canon 300 or 350d (£500 body only) unless you want a really serious camera!(£800 upwards) then buy lenses you need
for something in between Fuji are bringing a new one out this month see
here
gonna be around the £450 range.
Whatever you decide to get let me know before you go out and buy and I will give you some good links to get a good price