Holy Island is a magical place, rich with nature and history – and best enjoyed when the tide comes in, writes Helen Wilson-Beevers