Usually on close ended chambers, the water spigot is after the stinger, such as the 750 pipe and the blaster mod chamber. It is on the tail of the stinger in open ended chambers, such as the SJ one and others.
Its to cool, quiet, and modify the speed of the exhaust gas. The Xscream...