Hey nancyinaz,
I think I know your prob. When the sound "rises and falls with the activity", it seems to be the powermanagement-issue with some hardisks, which indirectly causes the interior fan to accelerate and fall back in short time-intervals. A proper solution in this (and only this) case is the tool "hdapm.dmg", which is downloadable here:
http://mckinlay.net.nz/hdapm/
download it and mount the dmg file, then follow the installation-process. The tool adjusts the pm-settings according to your drive, based on a large databank.
In my case (Macbook late 2006), it works wonderful. No more hassle with ANY strange sounds from the machine and porper performance without "dead seconds"
If the issue is not gone afterwards, replace the hdd.
Hope it helps, best regards,
chrishees