In 1, "at" points to the location (the cow is at the pond and is drinking water). In 2, "from" refers to the source of water (the cow could as well be drinking water from a bucket).
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.