Also, I often go away on business trips, can someone recommend an
automatic watering system that works well.
Something I can fill up with water and operates on batteries (I don't
have a hose outlet near my balcony).

This stuff works pretty well, and you don't need any batteries or any
other power source:
http://www.blumat-shop.de/index.php?language=en