Hundreds of council employees earned more than the prime minister in the last financial year, new research suggests.