Take a look at the recommended hard drive list
From personal experience I can tell you that a 7K RPM 3.5" drive is out of the question.
The Samsung F4 is at the top of the list for 3.5" drives. I have a 2TB model. It is very quiet in idle, but I can hear seeks. Vibration is listed as an 8 out of 10 for the 500GB model tested, I would rate mine a little lower at 6 or 7. If you don't want to hear the seek noise you need some dampening, either for the case or the drive.
In my notebook I use a WD Scorpio Blue 2.5" 500GB drive. I can hear seeks very slightly when the notebook starts and the fan is on the lowest setting. As soon as the fans spins up a bit it drowns out the drive.
For the absolute most silent operation you can put a 2.5" 5K drive in a Scythe Quietdrive enclosure.
Western Digital drives have a a power saving feature that parks the hard drive heads when the drive isn't accessed in some time. This is done a bit aggressively leading to a high number of head unloads and loads. I haven't heard of actual failures except when Linux accesses the drive repeatedly at an interval just a little bigger than the time for the head park. It is a potential point of failure, to be sure you could go with a Samsung drive.