A subsea cable connecting northeast Scotland with Shetland is to be manufactured in Scotland for the first time.