It could be done with a non-scissor table but it will be a great deal easier with a scissor lift.I reckon the best way would be with a scissor table, powered by compressed air, or a remote hydraulic pump. Not sure that the foot levers could easily be used if recessed.
I reckon that a standard manual operation will do.I've not figured out how the usual type of locking pin/bar could work, if it's within a floor recess.
Scissor-lift benches don't seem to use a lock-bar, they have a ratchet type lock but that said, the bar on my Sealey doesn't have to be horizontal when it's inserted through the first side. Alternatively, cut the lock-bar into two separate, short, lengths, it will still do the job.
When it comes to the foot-pump levers, I've always removed the ones on my lift when not actually raising or lowering the table and it would be simple to include a recess to one side, in which the levers operate, then use checkerplate or similar to make a cover.
I'm planning on lining the pit for the table with blocks so making a small recess on one side shouldn't be too difficult.