A psychiatric report is to be prepared on a former Fianna Fáil councillor before he is sentenced for being drunk and a danger; being threatening abusive or insulting; and carrying a knife.