I doubt very much if there is any particular Scots connection for the name Drinkard or Drinkwater which sounds an archetypical English name. Have you done a surname search (someone posted a link here recently) which may give you a clue? They may be best going for one of the universal tartans in that case.