Former St Helens hooker Scott Moore has agreed a two-year deal to join NRL side North Queensland Cowboys.