I cannot contribute anything regarding the service phases.
Regarding the floor plan: there are no major mistakes in it now. Personally, I am not a fan of a long narrow pantry. I would rather leave out the pantry and plan the kitchen more spaciously and comfortably.
I rather have a problem accepting the granny flat as it is.
The line of thought is as follows: the granny flat should be included so that the older generation initially grows up with the kids and later is not "alone."
Through the separate stair access outside, I do not see the "with" or "not alone." There is definitely a difference whether you have a staircase inside the building or outside. Especially for an older person, because they might need more time with a staircase, where resting on the steps could play a role, which would rather cause the person to stay in the apartment and avoid the stairs.
Also, the outside view suggests a view to the outside, but if you consider the location of the basement apartment carefully, a normally sized person can only look at a concrete wall from the inside. The terrace strip may be long and therefore large, but that does not change the fact that it is unattractive, being a 2-meter-wide strip and 2 meters below the surface.
If necessary, "only" the apartment would be rented out.
I take up the word "necessity" and say: it is an emergency (makeshift) apartment. Who wants to rent that?
Regarding the sleeping area, nothing more needs to be said. In my opinion, I would arrange the sleeping area at the bottom of the plan anyway, and the kitchen near the entrance. Then the underground terrace strip can be shorter and designed with a slope becoming deeper in the sense of wider and attractive, with planting facing the garden. Understandable?
Study (later possibly bedroom in old age)
That is a joke.