what is the noise? a click, click, click noise? buzzing, grinding noise,a hum? it could be a lot of things depending on what kind of noise its making.
you said you swapped power and sata cables, did you also try a differant HDD? have you tried connecting to a differant sata port on the mainboard?
on first impressions it sounds like a dead HDD to be honest but you may still be able to recover your data at least.