Photographer Giles Norman throws open the doors of his Kinsale townhouse which had just undergone a classic makeover to become an uber-tasteful place to stay, writes Rose Martin