Historic Church on the outskirts of Tenby to reopen after restoration