No offense to anyone here,
I am not sure about the CF's own TRUE needs for foreign languages, but the languages to know nowadays if one wants to be in the fast track in the foreign affairs area or international business area are Spanish, Mandarin Chinese and Arabic.
The reasons I say Spanish are obvious, especially if you lived in the US or have been to Mexico or any Latin American nation.
I also say Mandarin Chinese, because of the growing emergence of China as a world economic (and even military) power as well as the fact that overseas Chinese minorities (Hua Qiao) own most of the local companies/large comglomerates in neighboring Southeast Asian nations such as Indonesia, Singapore and the Philippines. Don't forget that Hong Kong, Macao, Singapore and Taiwan (the ROC) are also within the Chinese cultural sphere, though they used to be (HK, Macao) or are still seperate nations (please no Taiwan independence debate here). Plus there's the 2 million man strong, nuclear-armed Chinese People's Liberation Army to worry about.
Since you yourself are going into the CF, you must consider Arabic or Pashtun especially with the CF's large presence in Afghanistan now. Even if the CF withdraws from Afghanistan, the Islamic minority in Canada are still a concern for those dealing with counterrorism issues, so either language will be handy if the threat of homegrown Islamic fundamentalist terrorists in Canada proves real.
Consider going to a local university or community college if they offer any of these languages- there are lots of Study Abroad programs for Arabic.
If you're willing to spend and study in the US, consider the Monterey Institute in California- I think a US military postgraduate school is also there, as well as some extension of the Defense Language Institute, though I assume the DLI is only for US citizens.
Here's the Monterey Institute link and check out the non-degree intensive Arabic program at the bottom of the page.
http://www.miis.edu/
So the best course of action would be to go back to school if you still want to be a language specialist.