Water hardness has a dramatic effect on the flavour of coffee. This effect is difficult to predict, as tap water varies greatly from city to city. Your favourite cafe knows this and uses complex filtration systems to control and customise their water.
It’s why the coffee always tastes great.