A deer had to be shot dead after running wild around a Sheffield estate, say police.