One of the biggest urban regeneration projects in the country has officially opened today in north county Dublin.