Hi!
Here’s a starting point, look into making an alpha erosion effect:
this is how my texture looks like:
and this is how it looks animated:
To make it erode with some direction to it, you can multiply a gradient on the texture before you plug it into the erosion part. To create the texture, in substance designer you can draw a vector shape of it and use the distance node to get the inwards gradient. In photoshop, try the blending options, some of them might give you what you need.