What is a water sprout?

Nothing. Are you asking about a waterspout? That is another Word for a tornado over water. A spout can also be a spigot or funnel through which liquids travel, like a spout on a teapot.