Colin Leggat was last seen in his home village between Northalleton and Thirsk a couple of days ago