Outdoor shower/water day for kids.Could easily be made with hollow box uprights, run the water tube through one and the top hollow box with a PVC tube that you drill holes in for the water to run out. Faux paint it to look like copper, really pretty easy.
Dog water fountain Water features do not have to be massive in size. One like this usually has a water reserve like a 5 gallon bucket placed under the ground with a recycle pump. The rocks cover the reservoir and allow the water to flow back to the pump.