Holy water is in fact a form of moonshine favoured by priests and often brewed in church fonts.
It gets its name after the exclamation following the first takes when the peraon invariably exclaims, "Holy...", and then remembers they were in a church and can't say sheet, so then say, "...water!!!"
And thus Holy Water, often accompanied with a nudge and a wink, was thus named.