AI Foundation Models for Weather and Climate: Applications, Design, and Implementation