I have been to the Red Palace, as they call it, Ras Amassa on the Corniche near the Doha Club. It looks kind of touristy from the outside, but after a few hours it is full of Qataris. There were several families there too. There are different rooms to sit in, both inside and out, and a family section. The snacks are good and I had good service especially when I was with a Qatari. The sheesha was nice and they frequently replaced the charcoal.