The sentence would be:
"A lot of water was wasted."
Here, "was" is the correct verb to use because "water" is singular, and the sentence is in the past tense. The phrase "a lot of" functions as a quantity expression and does not change the singular verb agreement.