A sex offender who conspired with a mother to carry out the "most appalling abuse imaginable" planned to travel to Canada to rape her children, the National Crime Agency (NCA) has said.