The dog sustained serious injuries and had to have a leg amputated after a horror incident involving a City of Edinburgh Council vehicle.