I've used the Green Water Magic filter a lot and they work incredibly well.
Two points:
1. You need to manually white balance with them. If your subject changes depth by more than 2m or so, you need to re-white balance.
2. You need to shoot at a slight downward angle. If you get to much ambient light from the surface, this produces a color cast.
In terms of mounting, I tend to get a small piece of the filter and stick it onto the rear end of the lens with some tape as they demonstrate with the Tokina 10-17mm here: http://www.magic-filters.com/tokina.html
In cold green water, with this filter, you can actually extract more detail from a scene than your eyes can make out....
Adam