We stayed at Vila Gara. Great small pousada with super friendly staff. Ilha do Guajiru is quite pricey place to stay but absolutely worth visiting if you like flat water!
Depends on the tides. During low tides, it can be totally dry. Usually it's knee to chest deep. Great place to beginners to learn kiting, maybe the best in NE Brazil