It isn't a new NPC or a whole new way to play, but here it is. Head over to the zoo and head north from the entrance and you'll see a dirty hose. You can drink from it (drink hose or drink dirty hose) and basically have an infinite supply of dirty water.
Warning: We're not promising it's water, but it seems to slake the thirst!