It is generally advised to drink bottled or treated water during your stay in Nainital. Most of the hotels will provide bottled water to their guests.