A police officer has been killed in a shooting at a hotel in Canada that also left a civilian and a suspected gunman dead.