There's a downloadable underwater scene setup/shader from Duncan Brinsmead called envWaterFog v1.0 over at highend3D in the shader secton. You can see a simple render I did with it here.