Your CPU clock goal is low.. you'll be more then fine
It would depend on what is the bottleneck in your system as to how much effort you would logicly want to put into cooling it.. If the GFX is the bottleneck you would want to put more effort into cooling it (your current one would be but an upgrade to 8800+ wouldn't)
So, current GFX it would make sence to chill it or direct die it. DX10 card? Even water cooled it the CPU would still be the bottlneck under full force direct die Phase.
I would deside now if your thinking about upgrading GFX's any time soon.. if so.. I would just get to getting the CPU as cold as possible and clock the CPU and Ram as high as possible (near 300W heat load capasity on a SS DD wouldn't be overkill IMHO)
its driving me nuts seeing water over and over again
its Liquid vapor phase change cooling for a reason, water freezes
Alot of people avoid rotarys because most of them are loud under opeation, but if you can find a relitvley quiet one they are a good choice for performance (power) and by design then release less heat into the system.
for a single heat source DD SS, I wouldnt mess around with anything less then 1/3HP normaly (for more heat load capasity) all the way down to 1/5 would be functional however.. for your goals.. 1/2HP would be BIG (take the wattage of the compressor into consideration when selecting a condinser for the system, heat loads you want + the compressor + 3% (line loss and such) = capasity your condensor needs to be)