Working with a bicoastal design team, the artist homeowner crafted a modern, waterfront abode that feels welcoming but offers ample private space for relaxation and respite