The most polite and idiomatic way to ask would be Please may I get some water. May I have is also fine, but it sounds like you're asking them to get the water for you. Get makes it clear you will draw the water from the fountain yourself once you've had the approval to do so.