More than eight million households have been placed under hosepipe bans, raising questions about how effectively water resources are being managed.