Faucet is the most common term in the US, similar in use to "tap" in British English, e.g. "water faucet" (although the term "tap" is also used in the US). Spigot is used by professionals in the trade (such as plumbers), and typically refers to an outdoor fixture.