A multi-million pound investment in Port of Dundee will put it at the forefront of the decommissioning and offshore wind sectors, its owners say.