A social media post by the leader of the Welsh Conservatives "brought the Senedd into disrepute", a report has found.