A proposed sand mine on Perth's southern fringe has sparked community concern, with both the local and state governments weighing up environmental impacts against the need to boost housing supply.