It depends which MDD you go for...
Well, some of the early MDD's where loud because of the fans Apple used to put in the powersupply. However it is very important to know that the latest editions are really ok and not loud any more. Apple had a powersupply replacement program for free and they put those in there later MDD models.
If you go for a model that was produced at the end of the G4 MDD line, you will not experiment issues regarding noise.
Check out the Apple history site to find out which model numbers they had. The last ones where the MDD 1,42 Gig with FW800. After that one they had a last edition, which was a single 1,25 gig as far as I know. They did the last edition because of some Mac os 9 users because this was the last that could boot from os9.
In addition to that just in case you did not buy your G4 yet, you want to buy a G4 with verax fans. From time to time there are G4 verax systems on the market. they appear seldom but they are the best systems out there on ebay.
Anywas, if you cant get a late model for a low price tag, you still can change the fans yourself, which is not a problem. The low noise fan Panaflow with hydro bearing works great in my system. The verax fans where the best ones till today, however they are not on the market any more.
Good luck, my G4 beats most of the G5's, it's an awsome system!