صحيح مسلم
From Sahih Muslim (Hadith 5280):
Ibn Abbas reported:I served. (water of) Zamzam to Allah's Messenger (ﷺ), and he drank it while standing
Reference: Muslim 5280