Waterspouts form from the cloud down, not from the water up!
A waterspout is a column of cloud-filled wind rotating over a body of water, descending from a cumulus cloud.
There are two kinds of waterspouts, ones that form in fair weather and others that form during tornadoes.
Tornadic waterspouts usually start as true tornadoes over land following a thunderstorm (cumulonimbus clouds) and then move out over the water. Although they will weaken over the water, they can still be large, dangerous, and cause damage to trees and homes.
Fair-weather waterspouts, on the other hand, form only over open water. They are connected to dark, flat-bottomed cumulus clouds that develop vertically. Since the clouds don’t move, they tend to stay in one place.
Waterspouts are usually small, relatively brief, and less dangerous. Thankfully, fair-weather waterspouts are the most common variety. They’re typically seen in late spring and summer.