Newcastle City Council said it would "serve as a lasting tribute to a man who meant so much to the city" following the death of football legend Kevin Keegan in July