Water footprint assessment in space and time to support local and global sustainability