The human body contains approximately 60% water on average. (According to this site). The spell "create/destroy water" states "You destroy up to 10 gallons of water in an open container within range." In addition, "When you cast this spell using a spell slot of 2nd level or higher, you create or destroy 10 additional gallons of water". A gallon of water weighs roughly 8.35 pounds (according to this site).
Say there's a human who weighs 200 pounds. 60% of 200 is 120 - approximately 120 pounds of water are in this person. dividing 120 by 8.35 = around 14 - so those 120 pounds of water are, in other words, around 14 gallons. The destroy water spell can destroy up to 20 gallons.
According to these measurements, "destroy water" could theoretically completely dehydrate a 200 lb human.
The biggest argument against this in my eyes is that the water must be in an "open container". However, the human body is technically the container of the water. Thus, if a barbarian takes a big slash across the torso, resulting in a large open wound, the wounded human may, technically, count as an "open container".
Now, the 64 million dollar question - would "destroy water" dehydrate a human with an open wound, removing all water from their body and instantly killing them?