Four people in Canada, including two children, have been reported missing in flooding caused by torrential rains in Nova Scotia, police have said.