This impressive property in Union Hall has served as a guesthouse and a family home, writes Tommy Barker