I think that for now at least Apple is directing people who want quiet systems to the iMac. Power users must, alas, put up with fan noise.
I have read accounts of various users modifying their G4s with new fans, carboard mufflers, fan grille mods, etc., all in order to get a quieter machine...