A farmer drowned in water near his home in North Yorkshire, a coroner has said.