The new model Berlingo with the xtr spec would give you what you require.
It’s a pug 307 estate/picasso underneath i.e. it has decent suspension and brakes and handles better than older Berlingo models.
It’s not intended for pulling babes at the traffic lights, it’s a car and it does a job.
The 1.6hdi is a great mile eater and usually gives good all round economy.
Critically you can get three proper adults in the back if you really want to. The afforemention xtr model has removeable individual rear seats like a scenic, and would allow more flexibility.