I've heard of a fan upgrade for those noisy G4's. I have a noisy G4, but I have such severe tinnitis (ringing in the ears) that a little extra noise doesn't mean much. I'm sorry I don't have specific info about the fan upgrade to cure the G4 noise. I'd try some Mac forums for info. I sure wouldn't go to the expense of a G5 just for the noise problem. My brother is getting a G5 that should be arriving today. I'll let you know about the noise thing.
He's getting the G5 not because of any noise issue, but because you need it if you want to use the 30" monitor. The huge memory you can put in a G5 is also very nice if you want to have a large amount of stuff on the screen at once. The extreme speed of G5 for processing intensive stuff like raw conversion is also nice. I don't do much raw batch processing because I like doing individual tweaks like exposure, getting rid of vignetting and/or CA, etc. There's a lot of possible situations where a G4 keeps you waiting a lot longer than G5, but that depends on what sort of work you do and what file sizes you work with.
Maybe the best place to check about the G4 quiet fan thing would be Here
It's a site for pro digital audio and their forums have info about this. Go to "Support" in the top menu bar and then to "User Conference". This is where I first heard of the quiet fan upgrade.