The beautiful Skibbereen estate has revamped its hospitality business and is also free for walkers, writes Tommy Barker