Vishnu
Vishnu is a major Hindu deity (not a folklore creature), one of the Trimurti as Preserver. He reclines on the cosmic serpent Shesha in the Ocean of Milk and takes avatars (Rama, Krishna, Narasimha) to restore dharma. Classifying him as a 'water spirit' and 'mythical creature' is a category error — he is a supreme deity in Vedic and Puranic theology.