From the indoor swimming pool to the gorgeous grounds, this stunning north-east home was built to break the mould