The project presents several methods for creating static meshes dissolution effects using Niagara.
https://www.unrealengine.com/marketplace/en-US/product/dissolution-examples