The Quiet One by Rainbow Lifeguard is absolutely silent. However, it is direct drive and therefore puts more heat in the water than magnetic drive pumps.
I have 2 Little Giant pumps, a mag drive 1200GPH, and a new Dolphin ampmaster 3000. The mag drive is quiet as it is also submersible, and the dolphin is quieter IMO than the Little Giants (they both have fans and you have to judge pumps based on the presence or lack of a fan, and also on whether or not it's submersible or in-line) although the dolphin is pumping 2-3x the amount of water that the Little Giants are, and so the splashing is much louder in my open sump.
Iwaki's and GRI's are great pumps and quiet too. If you go Iwaki, stick w/ the Japanese made pumps as they're reported to be more reliable from the people that I've talked to...