The Government has given the green light for a multi-million euro tourism, commercial and residential development on the former Irish ISPAT site on Haulbowline, Co Cork.