well, that's relative (quiet and efficient)
these things are Peltier coolers, which are/have been known in geek circles for a while.
they are solid-state cooling devices used on heat-sinks for high powered and overclocked CPUs (and video chips, nowadays)
also, if you've ever seen the 'electric cooler' from Coleman (or others) or the 'auto cooler' that plugs into a cigarette lighter, these are Peltier effect coolers.
essentially, it's a plate that when electricity is applied to, makes one side of the plate hot and the other cold. if you reverse the polarity, the hot/cold sided reverse as well.
laws of thermodynamics and all that mean that they will always produce more heat than they abate (meaning that if you immersed the thing overall into the water, the water would heat.. for example, it would output +10degF and -6degF for a total +4degF, in a given volume... this is consistent with all electro-mechanical cooling systems.)
here's some Peltier info:
http://www.overclockers.com/tips45/
peltier's have about 5 - 8% efficiency, meaning that for every 100watt/hours of heat they remove (or cooling they provide) (you can convert to calories or BTU yourself, if you like) they consume 500 - 800 watt/hours of electricity.
so, therefore, the TOTAL heat generated would be 600-800watt/hours, ie the electricity consumed, plus the heat removed.
that's why these things make much better heaters than coolers...
for comparison, a typical compressor-type cooler has about 45% efficiency..
Peltiers can achieve very high temperature differentials if they are lightly loaded, but under load they don't perform as well, as the hotter they get the less efficient they become.
as for the noise issue, Peltiers themselves are totally silent, having no moving parts at all (not even vibration)
all of the noise will come from the heatsink fan, which of course needs to be a good one to keep the peltier (hot side) cool to keep the efficiency up.
the bottom line is that this is an interesting idea for small tanks, but everything will hinge on how well the heatsink/fan combo reject heat.
hum. one could experiment with this (it's difficult to damage a Peltier) with a tank, a heater and one of these coolers...
another idea would be to liquid-cool the 'hot' side of the Peltier. a small closed-loop system using a small radi
ator (like auto transmission/oil cooler) would probably be very good at rejecting heat, and also super-quiet.
anyhow, that's what i know about these coolers....