Slower RPM HDDs will generally be quieter than faster ones, and consumer drives will generally be quieter than enterprise drives at the cost of long term reliability and possibly write speed, but in general HDDs aren’t quiet, and no one specifically makes quiet HDDs.

Moving parts make noise. You’re more or less looking for something that doesn’t exist. Instead of looking for a quiet drive, look for ways to sound-isolate your drive.

Long SMART test, dd if=/dev/urandom of=/dev/[new disk], long smart test. That’s pretty much it.