A controversial council proposal to charge residents $300 to park in their own driveway has been scrapped after fierce pushback from the mayor.