An Edinburgh councillor who was elected by residents just days ago after promising to be a ‘real local champion’ has resigned and put her house up for sale.