Southern California is covered with guzzlers. Most of them are a concrete apron to collect rain water and a cistern. The cistern is covered and the apron is sloped so small animals can get to the water. I've seen some cisterns in the 55g range and some to several hundred gallons. Most of them had brush piles nearby to provide cover for the birds and small animals. To help the animals CA game regs prohibited hunting within, if I remember right 200yds of a water source.
So to answer your question. If it's a reliable water source the animals will be around it. However, if it's an intermittent source they may or may not be there.
