Is there a failsafe on this, for example, while on vacation if the timer malfunctions will it shut itself off at some point? And what happens if the battery dies while the water is flowing?

The batteries should last a full season. If the batteries were left in longer than their lifespan, the valve would continue to be either open or closed, depending on the state of the timer at the time of the battery failure.