A consortium has been appointed to transform the former Haulbowline steelworks dump into a multimillion-euro park and tourist attraction.