We are using non-potable water for irrigation. For drought conditions, can we hook up to a potable water source for backup and still earn this credit?

Yes. According to LEED Interpretation #998, "The approach of designing rainwater storage for a 'normal' rainfall year and providing potable water as backup is acceptable."