A cpu heatsink is designed to help cool a cpu. The speed of a heatsink fan can be controlled by the motherboard based on cpu temperature.
Fan noise is relative. One person's quiet fan is another person's vacuum cleaner.
Here is a link to a very good web site with a lot of useful information about quiet pc's that will help you make an informed decision:http://www.silentpcreview.com/