I'm still very much an amateur, but I can give a view on your questions.
- Can a small space add value for wildlife? Emphatically yes. For a small garden near houses I would aim for insects and birds. Creating lots of small mammal habitat may just encourage rats. Trees (as you planned) and ahrubs (especially thorny ones for protection) are great for birds. Blackbirds love picking through disturbed soil or woodchip as well, so just working the garden may attract them. Easiest thing for insects is get any plants in other than grass, and some flowering ones for pollinators. To a degree anything will work, but things like clover and dandelions in the grass are a very easy first step.
- can you make a pond without a liner? Yes, maybe. Look up puddles clay. The other option is to make container pond from an old sink, barrel etc. If they aren't already watertight you know the exact size for liners.
- soil. I wouldn't bother strippinf turf. Lay cardboard on top of the grass and mulch areas you want to plant. I'd you do dignit out stack the turf grass to grass and root to root and it'll decompose giving nice useable soil for raised beds etc.
- edible perennials. Easiest are probably berries like redcurrant, raspberry, wild strawberry etc. Leafy ones are possible, may e something like a hawthorn for hedging, bird habitat and edible young leaves.
- soil again. You are probably thinking about wildflower meadows, which thrive better on poor soil because the grass competes too well especially on good soil. You can so use yellow rattle to suppress the grass. Some plants, like clover, thistles and dandelions will compete well.in a lawn area regardless.
- embodied energy/carbon. Grow what you can from seeds or cuttings you've taken. You can get cuttings from friends and neighbours usually with minimal drama. If you do buy plants try to find local nurseries to minimise transport. Avoid imported plants where possible because of the risks of importing diseases. Cuttings and seeds have the advantage of also generally avoiding importing pests like vine weevils. If you do buy plants get small ones. They usually establish better anyway.
It's an exciting project! You can make it a really lovely space. As you design, think about the sun, shade and rainfall each part gets. Get big, slow growers right by thinking carefully. Smaller or faster plants can be moved or regrown if they don't work out, so much easier to play with.