What are the rules around driving a friend or relative's car in Germany?

If you want to travel around in Germany, a friend, relative or maybe a neighbour might offer you their vehicle to use. But what does the law say about driving someone else's car in Germany?