Not sure if this is quite what you want. Try applying a volume material to a shape (like a rock) and placing it under the water. Play with the shape and color untill you get the effect you want. Here is what I came up with. Still needs work.