I built my .4 acre pond with Komatsu D31 which is equivalent to a Catepillar D3. I wouldn't go more than one size smaller than that.

It also depends on how much dirt you have to move. Will the pond be excavated or are you building a dam? My pond was mostly excavated with a small dam. We used our backhoe with a 2 yard bucket to move most of the dirt.