I wouldn't bother with those losed looped water cooling kits. The fact is that they don't cool any better than high-end air cooling like a Noctua D14. To answer your question it will depend on a couple things, how much you want to spend and the case you have.
Well a Hyper 212 Evo will work just fine. If you want to go with really high-end air cooling I would go with the Noctua D14. The Evo is 35 dollars and the Noctua is 80 or 90 dollars depending on which model you get.