Considered ‘one of the great pillars’ of cinema in the province, he championed an unlikely hit that received Canada’s first Oscar nomination in international film