all fans make noise. It varies in how much noise they make and the Tuniq does fairly well> It even comes with a fan controller to let you adjust the fan speed, but remember fan speed = cooling power.
If you want something more quiet than a fan then you need to look into water cooling.
The AM3 socket is fairly hard to find a good cooler for, just because of the proximity of the RAM to the CPU socket. I personally recommend the Thermalright MUX-120.
If your motherboard is the GD70, then here's a suggestion to everyone else: PLEASE, do some research on clearances before you post something. I was looking for a good aftermarket fan for the same exact motherboard a couple months ago, and not a single one of the suggestions would fit with 4 filled DIMMs, which the OP will probably have one day. If you don't believe me, go look at some pictures and get measurements on the distance to the RAM slots. Just a heads up.