The ruling alliance's flagship rural employment programme took unprecedented strides in creating water conservation structures across the country, but only to harvest disillusionment. What went wrong? Richard Mahapatra travels to Jharkhand, M Suchitra to Andhra Pradesh and Moyna to Madhya Pradesh and Rajasthan in search of answers