Bad if too much
You don't specify if you are trying to achieve a certain goal by using lemon water. I am assuming you are inquiring about drinking lemon water. In general drinking water is a safe activity, but as always there are dangers if done excessively or under certain conditions.
Flavoring water with lemon juice falls into the same venue. See http://en.Wikipedia.Org/wiki/water_intoxication.