I think the Water Fountain Tap by Niels van Hoof is quite a clever design. It integrates a faucet with a fountain spout to make it convenient to drink. He suggests linking the fountain spout directly to the cold-water source, so that when you put the handle downwards, you get your refreshing drink of water. To activate the faucet as a normal tap, you just need to pull it back and turn it left or right. Simple and doable!
Designer: Niels van Hoof