New research reveals the Local Authority areas with the worst – and the best – roads