Simply, AT is high on consumption no matter whichever car you buy. MT is better if your really concerned abt the fuel and pickup.
No, AC's do not run on battery. The compressor is run by a belt connected to the engine by a pulley. The fuel consumption increases on a perfectly tuned car on average to abt 10%. Considering the traffic conditions and no problem with the fuel you can go for AT.