Since water has no calories in it drinking a lot of water should not make you gain any weight but drinking a lot of water can make you bloated or at least feel bloated.
Certain diseases such as kidney disease can make a person retain a lot of water which might cause them to gain weight so if you think you might be gaining more weight drinking water you should go see your doctor about it.