More than eight million households have been placed under hosepipe bans - which has raised questions about how effectively water resources are being managed.