DEEP DRILL WATER FOR IRRIGATION

I m wondering where is the best spot to get enough water for irrigation in dry season ? In clay soil,sandy ?, flat surface ? Up hill,down hill or valley surface ?

Thanks