Russ Mould travels to his native Yorkshire and discovers a thriving community of listed firms where there is no shortage of confidence in the future