Here are some examples:
* Not capitalized: The priest sprinkled the holy water on the congregation.
* Capitalized: The Church of the Holy Water is located on Main Street.
It's important to note that "Holy Water" as a title, like a book or a movie, would be capitalized.