If you do the proper paperwork, you can bring anything that is legal to own in Canada.
Pistols are severely restricted. Anything with a short barrel or low caliber has a very good chance of being on the "prohibited" list. Go to the RCMP link and look for "prohibited" firearms. It is a long list. There is another list that has true low caliber target pistols that are "exempt" from the general prohibitions.
Long before you leave the US start the process to obtain your PAL. The PAL will allow you to bring you pistols into Canada, and also is your ID when you purchase ammo (or new to you firearms)
The long gun registration is gone, but you will still need to declare any long gun you bring with you. Be VERY careful following their firearms laws. They take them very seriously...like $50K and 5 years for illegal possession.