In the course of building several computers, my inclination has ranged from running the stock HSF off the mobo CPU fan-header (Pentium 2, socket 1) to using manually controlled (infrequently changed) switches (ThermalTake Volcano (x)), to front-panel (manual) fan controllers, to "programmable" thermally-driven fan-controllers, and back to the use of the CPU_FAN header -- this time using SpeedFan.
There are a range of solutions that include adequate cooling that may be quieter (the Speeze Masscool), to even cooler and quieter (XP90 or XP120 with a carefully chosen fan). One solution I used for a while was a ThermalTake PIPE101 heatpipe-heatsink with a 120mm-to-92mm fan adapter and a high-volume, low(er)-speed 120mm fan.
Yet, with many 800-FSB motherboards, even these solutions can be driven from the CPU_FAN header on the motherboard. It then becomes a question as to how much you want to spend (varying $10, $20, $30 etc. either way) with some combo solutions costing between $40 and $70. Thus you might find an XP120 for as little as $45; you'll probably have to buy some Arctic Silver 5 thermal grease for maybe $5; and the fan may cost you as little as $8 and as much as $20 depending on its quality and "extra" features. The Speeze cooler already mentioned is only about $13.
It's too easy to recommend a single solution, although you may not have time to investigate and then decide which is for you. Already, there are some good recommendations previously posted. If there isn't a problem with your CPU fan -- an imbalance in the blade or motor or some damage to the bearings (whatever might cause undue noise) -- you might just want to find a way to muffle the sound. Materials like PaxMate help, but may not be completely or perfectly adequate given your "noise-tolerance preferences".