A waterfront, two-bedroom apartment with spectacular views of Sydney Harbour was transformed to accommodate the new owners' lifestyle and stunning artworks.