>> I suggest a large used tire with one side cut out on a concrete padI would use a larger than necessary tank to hold enough water for a few days and use a solar powered pump with a float level switch on it and discard the extra electricity. Very simple to set up. Just the tank and panels with a small pump and a switch like most watering systems have.
For tank you need something very durable - I suggest a large used tire with one side cut out on a concrete pad. That way when the water level is down and the cattle are pushing each other for it they will not damage the tank. A little more money to start but your worries should be over.
I would probably fence off 3 sides of the tank / trough to protect the overflow/drain and or float as other use here if they have a water well ?