A retired Catholic bishop who waved a blood-stained white handkerchief during Bloody Sunday is to be awarded the freedom of the city where the shootings took place.