If ambient noise is a concern, I’d go with an SSD. If money is tight, an HDD will give you the best value.

My server is in an otherwise quiet home office/sitting room, so I went with an 8TB SSD (870 QVO). Spinning disks make a fair bit of noise as the wake up and seek.