Thats definetely a health hazard. If the water stands long enough to get warm, it will get infected sooner or later.

Doesnt matter so much for the sistance between the main water pipe and your tap, byt after a holiday you should definetly let some water run until it comes out cold again.