There are no scheduled service flights by Canadian Forces aircraft anymore - there haven't been for years. I'm sure there are procedures to get a seat on unscheduled flights, but that would imply knowing when when one is coming up, and there being space available. I'm not sure if veterans are allowed to book, even in the unlikely event that they would find out about an upcoming flight in time to make a booking.
I think you'll find that some bases already do offer veterans access to quarters similar to that of Yukon Lodge in Trenton. I know Shearwater has family rooms available, and I think the new quarters in Halifax does as well, on a space-available basis. Best to check with each individual base's Base/Wing Accommodation section to find out details.