Plans have been approved to transform a city centre retail unit into a visitor attraction with a museum and education facility.