There was this movie, and unfortunately I remember very little about it. I remember seeing it at around 2001-2003ish, so it should be a film that was released before that time. The only things that I remember are that there was something to do with water, and by this, I mean like an ocean, or maybe it was something like a submarine or an oil rig, and I think that the main character was a guy, who was either a ghost, or a silvery liquid metally alien/liquidy thing, that looks a bit like the T-1000 in Terminator 2. Sorry for the lack of detail, and please help me remember this!
Are you thinking of this scene from The Abyss?
http://www.empireonline.com/features/history-of-cgi/p7
Michael Hutson is correct (see this post).