This is the infamous bar of Hadley's Hope in Aliens: Colonial Marines
You get there in the fifth campaign mission, The Raven
Looks like its been destroyed. In better days, it was a place for recreation for the colonists of Hadley's Hope. The Sign is still working.