Right, this all depends on what type of manual lens you want to use. I would recommend M42 lenses as these are the most common. You first need to get an M42 to EOS mount adaptor. These are very cheap, I got mine from Amazon for a couple of quid. Make sure you buy a 'flanged' adaptor as some auto M42 lenses did a similar thing to what Dean mentions with the aperture prior to shooting, via a small pin on the back of the lens. This pin needs to be pushed into the lens (via the flange) so the aperture ring works.
You put the adaptor onto the back of the lens then fit it to the camera in the usual manner. You then set the aperture wide open on the lens, and set your desired shutterspeed on the camera, as normal. Focus and then close the aperture to the desired setting. For macro, you will find you need a tripod, you might also find (as I do) that to focus accurately it is easier to get somewhere close and then move closer/further away to get it bang on.
I wouldn't bother at all with old Canon FD mount lenses - I can't remember exactly what the reasons are but these lenses don't adapt easily to the EOS system. Another type would be Tamron Adaptall lenses - these need a different type of adaptor. There are others but these are the main types.
As someone who fell in love with manual lenses recently, then fell out with them and recently fell back in love with them

my biggest piece of advice would be make sure you have the camera's viewfinder diopter adjustment correctly adjusted! Otherwise even though everything looks hunki dori in the viewfinder your shots will be out of focus.
Manual lenses aren't for everyone. Some find they just can't get on with them at all, but if you stick with it they are very rewarding, especially if you get some really good ones. I particularly recommend the Helios 44M series (58mm focal length, f2 - f22. I got two for £3 each) and Carl Zeiss Jena lenses, and Jupiter lenses too.