Is a waterspout a tornado

Yes it is a tornado over the water. However it is easier for a tornado to form over water and is generally smaller and weaker.

Waterspouts are generally not officially counted as tornadoes unless they hit land.