A SIN number is your ID number with the Canada government. It is used for your taxes. When you come to Canada on a work permit or as a PR, you need to apply for a SIN card so you can give the number to your employer. Without it, they can't pay you.
As far as I know, there is no difference between work visa and work permit.