A man and a dog have both died after the car they were in was found in the canal in Knottingley.