“Spigot” or “faucet” are more often used to refer to water valves, although this sense of “tap” is not uncommon, and the term “tap water” is the standard name for water from the faucet.