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