https://civitai.com/models/154217/water-dress
Stay hydrated!
Depending on the model this LoRA can vary between very wet looking dresses, or dresses that are straight-up formed out of water itself.
The main tag is water dress, but extra tags like transparent, rippling and dripping can help with the effect. See the example images for ideas.
Enjoy~