How about getting a sufficient length of hose and then attach it to the nearest tap and go hose down the balcony? When not in use you can just roll up and store the hose away.