All bottom areas should be compacted with whatever device that is being used for compaction. You dig a hole but it needs to be compacted well for it to hold water providing the dirt is proper for building a pond. Even with compaction many ponds leak due to poor building and compaction techniques. "You dig a hole, but build a pond." Holes never hold water for long.