The destruction depletion effect allows you to set a destruction mesh to destroy when the resource is depleted like the video below shows.

Below is how to use this feature in the different engine versions.

Unreal Engine 5

Unreal Engine 4