The suspect was also found dead after the shootings in British Columbia, police say, as Prime Minister Mark Carney says he is "devastated" by the "horrific" incidents.