The Physics of Water Masers observable with ALMA and SOFIA: Model Predictions for Evolved Stars