Hello, and welcome to PP!
Paphos is quite a small place really, so nowhere is very far from the tourist areas and beaches - main tourist areas are Kato Paphos/Harbour area (the main housing area near there is called "Universal") and Coral Bay, which is in Peyia region, where a lot of expats live.
Work-wise, it's quiet like everywhere at the moment, and didn't get too busy even in the peak of summer last year, but for bar/doorman work your best bet by far is the aptly named Bar Street, just up from the harbour, which has a concentration of bars and nearly all the clubs - a lot of them are shut just at the moment, and probably won't start opening up now until March at the earliest.