Martin Creed has paved an Edinburgh thoroughfare with richly coloured marble, bringing a splash of Italy to the city. It's the highlight of this year's art festival, says Jonathan Jones