I present the passport of the country I'm travelling to to the check in agent (in my case Australia) if needed. Upon leaving Australia, I have to present both passports at check in to confirm no visa requirement to Canada but my Australian at emigration so they can check me out. It's not a big deal. I travel on my Canadian anywhere else though, since it matches my accent (though not my birthplace)!