It has been confirmed that Ireland's first science park will be built in Cork with the potential for 6,000 new jobs.