The biggest city centre real estate project outside of Dublin over the next 10 years has received the green light today.