My limited experience of European cafes is:
1. No place would dare to serve you tap water - it is basically considered a health hazard, and many guests would be offended by being offered it.
2. Bottled water is an item on the menu and will cost you money.