Council devastated to miss out on drought funding