An analysis of irrigation intensity for sustainable agricultural development: a case study of tank irrigation in Andhra Pradesh