From the Super Mario Wiki
Water Spouts (or Water Geysers) are pillars of water that rise out of bottomless pits or out of other bodies of water, appearing in New Super Mario Bros. U. They help players across gaps and reach high places. If Mario jumps into one, he will be able to swim until the geyser pushes him to the top by its force. They appear in Above the Cheep Cheep Seas, Urchin Shoals and Waterspout Beach thet also appear in Larry Koopas Boss battle. , and are an integral part in navigating Sparkling Waters. They behave similarly to Sand Spouts, which also appear in the game as well as in New Super Mario Bros. Wii.
Fountains of water similar to Water Spouts appear in Super Princess Peach, where its spouting height can be decreased by using the Joy vibe. Also, geysers from the level Gushin' Geysers in Donkey Kong Country Returns 3D are also similar to Water Spouts as they can propel Donkey Kong and Diddy Kong upwards.