A new executive headteacher has been appointed to oversee two rural primary schools near Scarborough.