Water footprint and local hotspots