Will the SSD be as noisy as my HDD?

Typical hard drives will measure anywhere between 24 and 36 dBA depending on what they’re doing at the time (i.e. idle or seeking data).
In comparison SSD are effectively silent both when they’re idle and under load (reading or writing data).