"Another downside is that I need to get the water from the original water source to wherever I found soil suitable for digging the hole."

Clay is often found near riverbanks (etc). Otherwise, it often isn't even recognized as clay when it's dry.

Sue