The Duke of York pub in the city's railway station is set for a new name as part of a planned refurbishment which has been given the go ahead.