Sylvester Stallone has abandoned his plan to erect an 18-inch (46 cm) sea barrier to protect his Florida mansion after a fierce backlash from neighbours and local officials.