Steve Tandy is appointed Wales men's head coach and will lead the side into the 2027 World Cup in Australia.