If i understand correctly what you said, your video card does not work, so you are using the onboard video? Sounds like you need a new video card.
High pitched sound coming from the bonds? Do you mean on the video card? The motherboard?
Also you mentioend 2 HDD's died?
How is your power where you live? Do you have constant black outs, or brownouts? I also noticed your computer is quite old. How long have you had it?
It's hard to say what could be killing your HDD's...without knowing a little more information.