Best Way to Fill a Cylinder Vessel and Spill Fluid When It Breaks

Hi everyone,
I am working on a cylindrical aquarium in Unreal Engine. I want to fill the inside with fluid and control the fill level. When the glass breaks with Chaos, I want the fluid to leak and pour out from the broken area, like a real aquarium cracking open.

What is the best approach for this in UE5. Should I use Niagara Fluids? Any tips or examples would help. Thanks.