Generally, 5400RPM drives can be a little quieter, as the platters are spinning 25% slower. However, there are other things that can potentially affect that too, such as how many platters a particular drive uses, and whether the drive docks and undocks the read-write heads at idle, which can potentially make a clicking sound when that happens. Some sites used to review hard drive noise, but I think that's become less common as SSDs have become viable as a silent solution suitable for most tasks outside of bulk storage.
How a drive is mounted can also have a significant effect on noise. If your case has rubber dampers to attach the drive to within its cage, that should be quieter than if it's screwed directly into the metal cage, as...