Gavin Hamilton, who played international cricket for England and Scotland, has become the new managing director of Yorkshire, his former club.