As you know, the human brain is 70-80% water. In addition, water is responsible for delivering the stuff necessary for the brain to function properly. So yes, the brain works most efficiently when it does not lack H2O.
According to some studies, alcohol consumption destroys the connections between the brain cells. However, there is also good news: if you stop drinking alcohol, eventually, the brain returns to normal.