Innovative Water Intelligence: The Rise of Smart Water Management Systems