I just now saw this thread. I'll try to answer clearly:
Waterspouts are tornadoes over water. What gives a tornado much of its appearance is the dust and debris it picks up while on land. It's not an extension of the cloud all the way to the ground. So if a tornado is over the water, then it's picking up water (and likely fish and other stuff as well), thus the tornado takes on a watery appearance. Also, if a water spout moves from water to land, it starts picking up dust and debris and will become a tornado.
As for lake effect snow, there's a couple things to know. In the winter, large masses of water are almost always warmer than the surrounding air and land, and as long as its liquid, the temperature of the water is above freezing.* Further, an air mass is heated or cooled by the surface it is traveling over. Thus, when colder air travels over warmer surfaces, it tends to pick up moisture. Warm air can hold more moisture than colder air. And when that relatively warm, moist air goes over the colder land, the moisture condenses, freezes and falls as snow in a very quick time over a very small area. (I think last year Buffalo had something like 6 feet of lake effect snow fall along the coast and blocks away the streets were clear.)
Finally,
here's a link to the NWS Doppler Radar from the NWS office in Wilmington. I find that looping the base reflectivity gives the most useful views of what is going on with the weather. I also go to
weather.gov to get the best and most up to date forecast information for my area.
*technically this isn't always true for salt water, but the Great Lakes are fresh water, so we won't worry about that