The James Bond actor and his wife, fellow actor Rachel Weisz, split their time between New York and London