A waterspout, though not technically a tornado, is often called a "tornado over water." Though this quickly spinning column of air has the potential to be dangerous, they are usually weak.
That doesn't make them any less magnificent to watch, as long as you keep a safe distance.