Theoretically, that could happen sometime. Then the supply of drinking water takes priority. Here in the Berlin area, I don't seriously expect something like that because we have an extremely favorable geology from a water management perspective. In such a case, pumping from one's own wells would certainly also be prohibited. So only the use of previously collected rainwater would remain, and then we would be back to gigantic cisterns...
In practice, it would certainly be an advantage to have underground drip hoses whose operation no one can see. But that would again be unsupportive...
By the way, lawns should actually not be watered daily because that spoils them too much and they have no incentive to develop good roots. For lawns, one usually assumes 30 liters of water per square meter per week, which could be distributed over two sessions. However, lawns are actually a largely useless monoculture, so I have converted a lot of lawn area on my property into insect-friendly flowering meadows. And those explicitly want little water.