The synology itself is silent. The noise will depend on the drives you get.

Decide how much storage you want first. Take that number and double it. That's how much you should prob get cause it goes much faster than you'd expect. That'll dictate what size drives you need. Decide how many bays you need considering the noise you can tolerate. Generally bigger drives gonna be much louder under load.