Hi,
I think here are two pretty good videos on how to achieve this in Godot:
How to create the rain: https://www.youtube.com/watch?v=jWFXJcKZPcg
How to create the rain splash: https://www.youtube.com/watch?v=_RLMkGo-L3o
Please let me know if you come right with this.