A modeling and optimization framework for power systems design with operational flexibility and resilience against extreme heat waves and drought events