Question How to make a Sprite disappear with an effect?

Hope this is the right place to ask...
Anyone knows what this kind of function/effect would be called? Mesh, effect, sprite-effect-package...?

Image attached and I think it explains it well

When the player enter a boxcollider, I want a sprite to disappear in a beautiful "splashy" way. At the moment I make the sprite fade out. But I want to make it look more... Unique and special... But I have no clue where to begin. I mean, what would this type of effect be called?