Make a backup of your project before following this guide!
Go to the E_ResourceDepletedEffect and copy the video below.
Go to the BP_MasterResource and copy the video below.
Next go to the Effects collapsed node in the BP_MasterResource and create a new custom event and call it MulticastDestructionEffect then set its replicates to Multicast and tick on Reliable. Then copy the image below.

Next go to the Effects collapsed node in the BP_MasterResource and create a new custom event and call it MulticastHideDestructionEffect then set its replicates to Multicast and tick on Reliable. Then copy the image below.

Next go to the Effects collapsed node in the BP_MasterResource and create a new custom event and call it MulticastResetDestructionEffect then set its replicates to Multicast and tick on Reliable. Then copy the image below.

Copy the video below.
Next create a new function called SelectDestructionMesh and copy the image below.

Add the highlighted nodes shown in the image below, location at the top of the image.


Next add the nodes shown below.



Next click save all in the content browser and close your project, then download and unzip the folder linked below, then copy the video.
https://www.dropbox.com/s/w7nj7yj7cymskmr/SGK%20V2%20UE4%20Destruction%20Resources.zip?dl=0
Now go to the BP_MasterResource then click Class Defaults and set the Destruction Meshes shown in the image below, click the + button to add new entries to the Destruction Meshes setting. If you have other resources you want to use the destruction effect then you will need to set their static mesh here along with the destruction mesh you want that mesh to use when its destroyed.

Next go to the BP_StoneResource and in the Class Defaults set the Resource Depleted Effect to Destruction.
Next go to the BP_IronOreResource and in the Class Defaults set the Resource Depleted Effect to Destruction.
If you have other resources you want to use the destruction effect then you will need to set their Resource Depleted Effect setting in their resource blueprint to Destruction.