The chief executive of Rochdale council has been suspended following allegations of ‘inappropriate behaviour’.