Not all creatine products cause water retention and bloat, no. You just have to know which products do not. And generally creatine on its own does NOT do this, as, while it causes INTRAcellular water (i.e. the 'pumped' look) it does NOT cause extracellular water (i.e. the "bloat" look).
If you're lean using creatine should not make a difference in how you look.
If you want more muscle, then be prepared to gain some fat with it, though, as to gain muscle you need to be eating for it and such a diet means that fat will be added.
As far as creatine products, my top 3 recommendations are:
1. NeoVar Recomped
2. Cre-02
3. Kre-Alkalyn
~Rosie
Team APPNUT