Unfortunately you are not alone in this issue. I bought my MBP back in April, and the first week I noticed this problem. However, I did not think anything of it at the time. But after reading a few topics here on the problem, I know that my machine was suffering from the same problem.
I did notice a couple things in regards to the issue though. About a week or so I after I bought it, and updated to 10.5.2 and restarted etc. the sound went away. What caused it to go away, I have no clue, but it did. I use my MBP everyday, so I never shut it down and just let it sleep. In late May early June I did the software update and installed a few programs that required a restart. After restarting I used the machine for a few minutes then let it sleep. When I came back to use it, the sound returned.
It took about 3 weeks for it to go away this time, but it did again, and was silent until I had to reboot a couple months later and the sound returned again. In my experience, it seems to go away, but always returns after a reboot.
I am not so sure it is a sign that HD is failing because I use my machine for heavy HDTV capturing and editing, and it has not crashed on me as of yet (knock on wood), and its going on 7 months now.
I did as you are planning to do, and went to the Apple store, but they could not offer any insight as to why this is occurring. Their only solution was for a HD replacement and re-install of OSX 10.5. Feel free to take a trip to the store and report back here, I would be very interested to hear what they tell you.
As I am still under warranty and planning on purchasing Applecare shortly, I will have the drive replaced soon. But for now, I make sure to back up my files to an external just in case the drive does go.
May I ask when you bought your MBP, was it an early 2008 or the new one released this past October?
sorry I could not be of more help, I am still trying to figure out this problem on an otherwise great machine.
good luck and make sure to back up your files.