A couple of hours ago i accidentaly acheived this with my x-craft sub, the reflection model was in the wrong position and it looked for all the world like the water was transparent,
Its a cracking idea and as i found it does work, you do howwever loose your reflection