A New Forest councillor has called for long-term investment in water infrastructure following "alarmingly frequent" leaks.