One of my G4's I use for work is the dual 1.25 and I don't even notice that it is on. But for some strange reason when you first boot it up all the fans kick on but after boot I forget that it is running.
I have also noticed that with the 23" display pluged in it that is is a little bit louder. That probably goes without saying.
It is hot as hell though!!!