Sitting on a private 6.8-acre lot in Long Island's Oyster Bay, the stately home also boasts a private deepwater dock