dgolds

Personally, I'd kill for your job. Sure you have to take sensible precautions and be aware of what's going on around you. But Bogota is a great city.
Your hotel is fairly central(if my memory is correct) and close to a beautiful old colonial barrio called (I think) la Candelaria. Its also walking distance to a much touted restaurant named La Casa Vieja (funnily enough in an old house) where for a huge amount of money you can eat traditional colombian food that you could probably eat in any campesino's house for a millionth of the price. But it is served on nice plates and the place does have a nice atmosphere.

As for the water, well when I'm travelling I'd drink the water out of the Ganges so if I was you I'd get someone else's advice about that!

Bogota is great and the Colombian people fantastic - do be prepared for some adventure though; nothing is predictable.