Plans to transform Newport docks into a zero-carbon port by 2040 have been welcomed by the council.