Yes cannabis can help with anxiety and have minimal effects on making you sleepy.
ACDC is a strain that is low in THC and high in CBD, which is what I would recommend for someone with anxiety.
ACDC is also a sativa strain so it should not get you as sleepy as an indica strain.
BartSmart