Manfrotto makes excellent tripod systems. But they are pricey for consumer grade cameras. You could easily spend more money on a Manfrotto than you did on your camera. People will tell you that you will keep your tripod forever but cameras come and go. I won't argue with that.
But if you find that the prices of the Manfrottos are more than you want to spend (you didn't mention any price range) I would suggest the following. You can buy the Sunpak tripod listed on
this web page which has a great set of legs and a very good head for shooting still photography. I would then buy the Velbon PH-368 fluid head found on
this web page which is an excellent video head. You can put it on the Sunpak legs and have a very good tripod for just over $100. This is a very popular setup on this board because it gives you about the cheapest tripod setup you can find that is still a quality setup. I will say that the Velbon head is made of mostly plastic parts but it has friction controls for panning and up and down movement which is rare on a tripod head in this price range.
I think you will find this is a very good setup for the money. If you have the money I'd say get a Manfrotto. But IMO that's a lot of tripod for the camera you own. With the Sunpak and Velbon combination you will have a good still head and an excellent video head for around $100. That's a hard deal to beat IMO. I've made this suggestion to a lot of people and no one that has bought this setup has ever said anything except good things about it. I suggest you do a search to see other people's comments on this setup.
The legs are oversized aluminum and there is a threaded stud on the bottom of the center tube that will allow for adding extra weight for even more stability. The Velbon tripod has all the features you will want in a video head. It is a true fluid head. The Sunpak head has 3 axis movement (the extra axis is for shooting portrait shots with a stills camera) and is very solid as a stills head.
I just don't think you can go wrong with this setup. It rivals more expensive heads and legs IMO. It is plastic which probably means it won't last as long as a Manfrotto but it should last for many years if you treat it right.
Good luck.