The sound is determined by what kind of drive it is. Consumer drives are for in-home use and are usually quiet. Enterprise drives are for dedicated server rooms or data centers and can get loud because it’s loud in there already.
I would recommend sticking with consumer level HDDs if this is a concern. The cost per TB isn’t as good.
I bought a 14 TB Seagate Exos and put it in a Fractal R5, which is a very good noise insulating case. I can hear clicking from anywhere on the same floor as that machine if I listen for it.
You could maybe pair two consumer drives together in JBOD to get the space you want, but that’s more expensive.