You may want to get the one without the G-Force shock protection as MacBooks have that built into the OS and the G-Force may cause issues. Plus you'll usually find the non G-Force versions go for a few dollars cheaper. I have a 7200 rpm 320GB Seagate drive in my alu MB and I haven't noticed considerable noise or vibration. And it's been as reliable as all heck. It all depends on how sensitive you are to the sound I suppose.
Oh, and just another suggestion, make a backup using Time Machine and do a full install of (Snow) Leopard and restore from TM. I found this works better than cloning the drive.