St John's to join with All Saints Weston-Super-Mare