The leader of the National Party has urged Barnaby Joyce to take leave after he mixed medication with alcohol and was filmed swearing into his phone while lying on his back on a Canberra street.