I would divide the terrace/outdoor area into 3 independent sections Family/Community/Parents-in-law Take a look at the thread by Granny flat for parents Slope location similar to yours just without the access problem
I cannot write anything about architects. However, there is a thread about construction companies around Heilbronn. Surely, some of them have also built on the slope. I would simply enter Heilbronn in the search function.
EDIT: A partition wall only provides visual privacy because you can still hear everything. It wouldn't be for me.