Hi, I got into both UBC MPH and McGill MScPH as well and I am still deciding between both programs. McGill is an MSc because of the heavy statistics and epidemiology component. In terms of your french, you will get by just fine in Montreal, as most people speak English. I did french immersion in high school and graduated bilingual, but it has been many years and I struggle speaking as well!
In terms of financial support, my first impression is that there are more scholarship opportunities and bursaries available at UBC. Perhaps this is because I am a BC resident, not a Quebec resident. I struggled to find information on financial support online for McGill, and my acceptance letter stated that there are no bursaries available to students in the program. However, you can apply for bursaries at UBC. You can also factor in the cost of living; the cost of living in Vancouver is extremely high, while Montreal is known for a much cheaper cost of living.