Train drivers have voted overwhelmingly to accept a multi-year pay offer, ending a two-year dispute at 16 rail companies including Northern and TransPennine Express.