In the Nintendo DS game, the water bottle appears in Market Square, next to the chip stand, behind a trash can—but only when your Sim's magic energy is low.