When do babies get water?

We just hit 6 months and I’m curious as to when baby can have water and do you recommend a soppy cup or regular cup? if so which one?

Obviously i will ask at the 6 month appointment but i’m just curious.