My G4 has a pretty noisy fan but it is nothing compared to the late G4s that were called "wind tunnels" by their critics. Apple actually put a version of my CPU in a laptop. But I have three hard drives and I assume heat is probably a bad thing for electrical componets (I still remember tubes) so I am being careful. I'll probably over-engineer something, if the past is a guide. "Remember the I35W bridge--who needs terrorists when there are Republicans"
http://www.silentpcreview.com/
And check the forums they're quite friendly:
http://www.silentpcreview.com/forums/
To get an efficient PC first thing you'll need an efficient power supply (PSU) and that means building your own PC since no brand name PC uses a really good PSU. By good here means high power efficiency meaning both lower elctrivity bill and less useless heat to evacuate hence more silent PC so every percent count :).