A significant shake-up is coming to Fremont’s live music scene as the sun sets on one pillar venue, making way for a splashy new opening around the block.