Italy's Olympic Committee has officially withdrawn its bid to stage the 2024 Games in Rome after the city council voted to oppose the candidacy.