I assume you will be doing this in the spring/summer, not now. If so, this is a great idea. If you are planning it for a few weeks from now... not a good idea. It simply isn't feasible in Canada in the winter. An experienced RV'r might be able to do it, but it would definitely be a struggle, and definitely not something for a newbie to tackle.
If you have until spring---take your time and do some reading up on what you need. You will likely need a properly set up weight distribution hitch and sway control system. You will need a trailer that lets you stay within the cargo capacity of your truck, with ample capacity for your family and supplies.
If you possibly have time, my suggestion is to buy an older used trailer (after your research). You are not sure if you will like RVing, and don't know what kind of RV will best suit your needs in the long run. You don't want to eat the depreciation of a new unit. Get a good inspection and make the seller do a thorough walk-through.
Find a heated storage so you can de-winterize and familiarize yourself with all the systems and continue to check them out.
I think you have a great idea and this could be a fun trip, just start it out right!
Single empty-nester in Middle TN, sometimes with a friend or grandchild on board