Nine people have been killed and 25 injured in the shootings at a school and home in a rural community in western Canada.