Community councils are elected - if there are more candidates than seats.
Hard to know how serious he is.
Even harder to know what is 'best'.
In my view, Scotland lost a lot when the Regional Councils were abolished.
Plenty of places throughout the world have decision making bodies - with substantial financial resources to make decisions about - that cover quite small areas/populations.
It's all related to democracy and what sorts of decisions need 'democratic control'.
I think there is probably a need for a decent transport authority with more power/resources than SEStran. Whether it should have a board mostly of local councillors or have its own elections is another matter.
I have no view as to whether Edinburgh or Lothian or Edinburgh's travel to work/education area should have an education authority - or just one for Scotland (modelled on PoliceScotland of course).
Currently local gov is overly controlled by SG which in turn is related to Westminster, which in turn has a relationship with Europe!
Lots needs looking at!
I'm sure if CCs were given more power/responsibility they would not be the same as they are today.