"Were you drinking water?"
Translation:Vy jste pili vodu?
In your sentence, jsi is an auxiliary forming part of the verb jsi pil. When it serves as an auxiliary, it cannot be the first word in the sentence. (The same would apply to the other forms of být in an auxiliary role.) And, yes, if you are asking a woman this question, you would use pila instead of pil.