On/off super-Brownian motion: Characterization, construction and long-term behaviour