Self-consistent GW approach for the unified description of ground and excited states of finite systems