XP or P4 cpu needs a fan on the heatsink. there are a couple of exotic HS that are passive, but theyre considered exotic for a reason, theyre really not suited to many.
on the SK-7 though you should have no problem with a quality 80mm low-rpm fan such as panaflo l1a, vantec stealth, or other low-rpm 80mm's from pabst/NMB. these i doubt you will hear over your case fans etc.
do you know what fan is currently atop your SK-7? you can remove the fan from that heatsink, indeed normally it comes without one and you have to buy seperately. open your case door and the fan should be held on with wire clips. simply unclip (and unplug) the current fan and replace with a new one. if your current fan is orange its probably a thermaltake "smart fan" which is LOUD - though it should have a little dial on the wire which you can turn to slow down the fan - keep an eye on cpu temps when you do this! note remember to turn OFF the pc when changing cpu fans! else you will likely kill the cpu very quickly.