I served (water from) Zamzam to Allah's Messenger (ﷺ), and he drank while standing, and he asked for it while he was near the House (i. e. House of Allah-Ka'ba).
Sahih Muslim Book 36, Hadith 157