There are traps in the main game that are similar to this idea. These mainly use item/character Scripts is what it looks like. PUZZLE_TurretAuto.itemScript is an example of a script that shoots a projectile over and over (used in the basement of the abandoned house in Cyseal, [X=682, Y=-33, Z=338.48])
If you want to create a one time thing you will most likely have to write your own script and I would use a ScriptFrame that explodes at self.