I would say it can be used as an informal invitation to have some coffee.
Imagine: a friends comes to see another friend. The host pours some coffee for himself. And then he offers:
"Попьёшь кофе со мной?"
or just
"Кофе попьёшь?"
In this context it is the same as
"Кофе будешь?"

I find it quite natural.