ANSWER:

It is not holy but rather blessed.

https://islamqa.info/en/answers/1698/merits-of-zamzam-water

QUESTION: Is Zamzam water considered holy? How do I easily explain to a non-Muslim what it is? Can I say it’s holy water, or like holy water but not in the Christian way (since everyone knows what that is)?