Well, the CPU itself won't make any more or less noise - though the fan will be on full-time. To be safe, you'll want to disable power savings and sleep/low-ower modes and have it running like a server - so it'll be a bit noisier.
But the big deal is fans.
Get a new case. You need a basic case with two 3.5 floppy slots and no front door. 120mm fan is a huge bonus.
- Replace all your fans with quieter ball bearing ones. I hard wire-mine into the power supply(bypass onboard control). They are on all the time. Pay attention to the motherboard - install a 50mm ball bearing fan($4 at most) on the southbridge and northbridge. OCd a board and found out the hard way a year later when the southbridge died, even though the temp was always good and it had a massive heatsink.
- Ditch the front fan. Useless.
- Use a Dremel or simmilar - any fan opening that has any sort of metal covering it - cut it out and replace it with a wire finger guard, like you see on your power supply.
- Install a slot fan. video card - blank slot - slot fan. This pulls half of the heat off of the video card. The problem isn't heat but heat that sits still and bakes itself into everything around it. If the top of your case is more than about 20 degrees over room temperature, you have too low airflow.
- put your HD in the lower 3.5 slot. Remove the cover above it. Yes, it's not terribly attractive, but it is your intake. Since it's smaller than the exhaust, it accelerates the air into the computer, cooling it down to 60 degrees or so. The exhaust fans will pull in as much air as they need through such an opening, so you can safely get rid of the intake fan. (cars work the same - it'll pull in as much air as it needs as long as it's not through a straw-sized opening.

)
This does a fantastic job of also cooling your hard drive for cheap - and the entire system has nearly zero backpressure on the fans other than the CPU fan. My Maxtor 300 gig HD, which is too hot to touch normally, is 85-90 degrees (F) as a result. Two years without a single hint of failure. My work - had some installed in blades with typical lack of airflow - 3 months or so before they roasted.
I also put a 3.5 floppy adaptor in the 5.25 bay above my DVD drive - same deal - pulling air over it and ditching the intake fan. Yes, since the case has two openings in the front, there is noise coming out of there, but it's half as loud as before. I'll probably move to water-cooling next, just because my CPU fan is making 2/3 of the remaining noise.