In the US, there is no difference. "Faucet" is used more commonly. Ian is exactly correct about tap water.
I could be wrong but I think that possibly "tap" means "the place where water can come out of a pipe," while "faucet" means "the device, including the handle and the valve, that controls the flow of water at a tap."