Yep, this is all from TS2. The shader is a separate package that comes with the Radiance download (it's called RLS-Shaders.package - just put it in your Downloads folder). If you have an older graphics card it might not work, though. It wouldn't with my ancient nVidia GeForce 7600GT, for example.
It's true, Radiance is way too dark, especially 2.4! I tweaked it for myself (or flailed my way around the settings) to lighten things up a bit. You don't need to install it for the water though, I think.