A consultant will be paid $30,000 to look at alternatives to artificial grass but one councillor has described it as “a waste of money”.