Can you use a gif as your steam profile picture?

Not an uploaded one, no. Steam only takes a still image for the avatar, so any gif you upload gets flattened to its first frame. The animated avatars all come from the Points Shop, and most of them cost a few thousand points. You'll often have that many already from past purchases without realising it.