Since water droplets look alike, you get the illusion, at the proper frequency setting, of water dripping up.

I wonder how it would look if a different dye was injected into the flow every few seconds, just above the faucet. Presumably, the colors would appear to flow down as the water appeared to drop up.