thanks for explaining your use case! there's a section on the tooltip for city statistics like connected settlements, that shows up when you hover over the city center. would it suit your needs if i added a "No Fresh Water" indicator to that section, like in this screenshot?
CivFanatics Forums
beezany