Easiest way is just to buy something that complies with the Affordable Rental Housing SEPP so you don't even have to go through council. Either way there is nothing in NSW stopping you from living in a granny flat and renting out the house. It's totally fine.