ProEco produces a wide array of fountain nozzles. The brass N111 Foam Jet Nozzle is available with 0.5", 0.75", 1", 1.5" and 2" MNPT inlets. The nozzle must remain underwater while the vent tube remains above.
The chart below shows the pump specs needed to produce desired display height. For example, to get a 3' display height with the 1" nozzle, you need a pump that produces 22.3gpm (1338gph) at 15' of head.