Tamworth Council water boss asks inquiry for more water security despite cost to irrigators