I'm going to give this Thermaltake Bigwater 760is that came with a Core2 system a bit of a whirl.
Sadly the mounting bracket only goes up to LGA775, I assume that there's one available for later socket types if I happen to want to use it elsewhere.
So far as the coolant goes, I've had a bit of a look around and don't want to fork out the ridiculous bucks they want for dedicated fluids and don't give a crap about UV lighting or what it looks like.
What I have found is various bits of advice relating to using automotive coolant and mixing with distilled or demineralized water.
The plan I have - I've got some half decent coolant that I think is 20% ethyl-glycol and also has the corrosion inhibitors. I also just bought some demineralized water for all of $1.70.
So, mix the 2 together probably with a ratio of 2:1 coolant/demin water.
More water = better cooling ability, the corrosion inhibitor should still be sufficient ratio and with the ethyl-glycol it's not really needed and is worse for cooling but does have the benefit as per cars in that it helps keep the corrosion inhibitor stable and should also help to keep any organic growth to a minimum.