Groupoids and $C^*$-algebras for left cancellative small categories