Hi!
Yes, CCA does pay for food, accomodation and transport, but there is a bus service that will take you to the flight school at a cost of 60 dollars per month, the most you would expect to pay for food and accomodation would be 1,000 per month, things are a lot cheaper here than Ireland.
The flight school that CCA uses is Algonquin flight center, you could try and go directly to the school, have you tried Moncton Flight College, can also JJA.
The about prices are based on North Bay.
The flight schools should help get somewhere to stay.
Best of luck