Revolutionizing Urban Energy Landscapes: A Robust Framework for Sustainable Integration through Advanced Smart Grid Architecture