Most effects like that use compressed air... usually a lot of it. I'm thinking, though, that a small pool would spray your visitors if your "explosion" got too big. YOu could try a pump, but you'd need it to start almost instantly and pump a huge volume of water. A small blast of compressed air is probably your best bet.