This is a waterspout and yes, it is real. According to oceanservice.noaa.gov, “Tornadic waterspouts are tornadoes that form over water, or move from land to water. They have the same characteristics as a land tornado. They are associated with severe thunderstorms, and are often accompanied by high winds and seas, large hail, and frequent dangerous lightning.”
Image Source: historydaily.org