pH is technically the measure of how much hydronium ion (H+) is in the water. It's based on the concentration of that ion in solution and it is mathematically expressed as a negative logarithm in base 10.
H2O <----> H+ + OH- pKa = 14
The above reaction is the most basic equation of chemistry.
When water has a pH of 7, there is an exact balance of [H+] and [OH-] ions. When water has a pH less than 7, there is more [H+] than [OH-] and we humans describe that with the adjective "acidic". When the water has a pH greater than 7, there are more [OH-] ions than [H+] and we humans use the word "alkaline" or "caustic" to describe it. When you add more acid to water, you add more [H+] ions and the the pH decreases. The reason why it decreases is because of the mathematics we use to describe what is happening in the equation above.