What kind of motion should you impact to the nozzle of a garden hose?

Question

so that the resulting stream of water approximates a sine curve

Answer 1

Think of the water coming out of the hose as a strip chart recorder. No movement and the "line" is flat. Move the hose nozzle up and down (or side to side) in regular amplitude, and you have a sine wave.